<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace 命名空间  该映射文件对应的映射器接口-->
<mapper namespace="com.ty.mapper.LoanSheetdetailsMapper">

    <update id="update">
        update erp_agent_inquiry_sheet_list
        <set>
            <if test=" relation_sn !=null and  relation_sn !=''">
                relation_sn =#{relationSn},
            </if>
            <if test=" customer_id !=null and  customer_id !=''">
                 customer_id =#{customerId},
            </if>
            <if test=" inquiry_date !=null and  inquiry_date !=''">
                inquiry_date =#{inquiryDate},
            </if>
            <if test=" type_of_goods !=null and  type_of_goods=''">
                type_of_goods =#{typeOfGoods},
            </if>
            <if test=" mode_of_transport !=null and  mode_of_transport=''">
                mode_of_transport =#{modeOfTransport},
            </if>
            <if test=" route !=null and  route=''">
                route =#{route},
            </if>
            <if test=" port_of_departure !=null and  port_of_departure=''">
                port_of_departure =#{portOfDeparture},
            </if>
            <if test=" port_of_destination !=null and  port_of_destination=''">
                port_of_destination =#{portOfDestination},
            </if>
            <if test=" quotationTerms !=null and  quotationTerms=''">
                quotation_terms =#{quotationTerms},
            </if>
            <if test=" goods_desc !=null and  goods_desc=''">
                goods_desc =#{goodsDesc},
            </if>
            <if test=" hs_code !=null and  hs_code=''">
                hs_code =#{hsCode},
            </if>
            <if test=" cabinet_type !=null and  cabinet_type=''">
                cabinet_type =#{cabinetType},
            </if>
        </set>
    </update>

    <!--<insert id="save">
       insert into erp_agent_inquiry_sheet_list set
           relation_sn =#{relationSn},
           customer_id =#{customerId},
           inquiry_date =#{inquiryDate},
           type_of_goods =#{typeOfGoods},
           mode_of_transport =#{modeOfTransport},
           route =#{route},
           port_of_departure =#{portOfDeparture},
           port_of_destination =#{portOfDestination},
           quotation_terms =#{quotationTerms},
           goods_desc =#{goodsDesc},
           hs_code =#{hsCode},
           cabinet_type =#{cabinetType},
           destination =#{destination},
           estimate_value =#{estimateValue},
           tariff_ratio =#{tariffRatio},
           ocean_freight =#{oceanFreight},
           customs_clearance =#{customsClearance},
           dispatch =#{dispatch}
    </insert>-->
</mapper>
